College tuition, diversity, and pay

• Many people are interested to know about the tuition, costs, diversity and potential salary when searching for college.
• In this project, we want to analyze tuition costs across different states, and explore diversity in different schools.
• The data set includes different variables such as school name, state, type of school, in-state/out-of-state tuition, group/racial/gender category, early/mid-career pay, stem percent and historical tuition information.
• We are also interested in trends of tuition over time. We will use different summary statistics and visualizations in R to address these problems.

Diversity dataset

diversity_school %>% glimpse()

## Rows: 50,655
## Columns: 5
## $ name             <chr> "University of Phoenix-Arizona", "University of Phoe…
## $ total_enrollment <dbl> 195059, 195059, 195059, 195059, 195059, 195059, 1950…
## $ state            <chr> "Arizona", "Arizona", "Arizona", "Arizona", "Arizona…
## $ category         <chr> "Women", "American Indian / Alaska Native", "Asian",…
## $ enrollment       <dbl> 134722, 876, 1959, 31455, 13984, 1019, 58209, 19039,…

Finding the most diverse campus per each diversity categories

## # A tibble: 11 x 6
##    category  university_name  state enrollment_rate total_enroll category_enroll
##    <chr>     <chr>            <chr>           <dbl>        <dbl>           <dbl>
##  1 American… Haskell Indian … Kans…           100            808             808
##  2 Asian     Grace Mission U… Cali…            95.5           88              84
##  3 Black     Lane College     Tenn…           100           1262            1262
##  4 Hispanic  Professional Ha… Flor…           100             37              37
##  5 Native H… Argosy Universi… Hawa…            49.7          933             464
##  6 Non-Resi… Knowledge Syste… Illi…            97.9          193             189
##  7 Total Mi… Lane College     Tenn…           100           1262            1262
##  8 Two Or M… University of H… Hawa…            40.1         2661            1068
##  9 Unknown   Le Cordon Bleu … Cali…            90.3          442             399
## 10 White     Rabbinical Semi… New …           100            500             500
## 11 Women     Spelman College  Geor…           100           2135            2135

Finding the most diverse campus per each diversity categories

Diversity map of the US for each diversity Group

Women enrollment rate across the US

Relationship between enrollment rate and in state tuition per each diversity group

Relationship between enrollment rate and out of state tuition per each diversity group

Tition cost dataset

tuition_cost %>% glimpse()

## Rows: 2,973
## Columns: 10
## $ name                 <chr> "Aaniiih Nakoda College", "Abilene Christian Uni…
## $ state                <chr> "Montana", "Texas", "Georgia", "Minnesota", "Cal…
## $ state_code           <chr> "MT", "TX", "GA", "MN", "CA", "CO", "NY", "NY", …
## $ type                 <chr> "Public", "Private", "Public", "For Profit", "Fo…
## $ degree_length        <chr> "2 Year", "4 Year", "2 Year", "2 Year", "4 Year"…
## $ room_and_board       <dbl> NA, 10350, 8474, NA, 16648, 8782, 16030, 11660, …
## $ in_state_tuition     <dbl> 2380, 34850, 4128, 17661, 27810, 9440, 38660, 53…
## $ in_state_total       <dbl> 2380, 45200, 12602, 17661, 44458, 18222, 54690, …
## $ out_of_state_tuition <dbl> 2380, 34850, 12550, 17661, 27810, 20456, 38660, …
## $ out_of_state_total   <dbl> 2380, 45200, 21024, 17661, 44458, 29238, 54690, …

Different types of colleges in US

How many collages are there in each state?

Comparing different states in terms of in state tuition

Comparing different states in terms of out of state tuition

Comparing in/out of state tuition (1/2)

Comparing in/out of state tuition (2/2)

In state tuition; different type of colleges; What is the relationship?

Out of state tuition; different type of colleges; What is the relationship?

Most expensive collages with out of state tuition

The chepeast Collleges in terms of out of state tuition

Most expensive collages with in state tuition

The cheapest collages in terms of in state tuition

The historical tuition dataset

270 observations and 4 variables

The historical tuition dataset

We observe that the data is available consistantly from 2000 till 2017.

##  [1] "1985-86" "1995-96" "2000-01" "2001-02" "2002-03" "2003-04" "2004-05"
##  [8] "2005-06" "2006-07" "2007-08" "2008-09" "2009-10" "2010-11" "2011-12"
## [15] "2012-13" "2013-14" "2014-15" "2015-16" "2016-17"

For convinience, we will consider the end of year.

##  [1] 1986 1996 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
## [16] 2014 2015 2016 2017

Average tuition cost over time

Tuition comparison between 2 year and 4 year programs

Salary potential dataset

935 observations and 5 variables including:

• University
• State
• Early career pay
• Mid career pay
• Stem percent

Which states have the highest/least early career pay?

Top 5 states

Which states have the highest/least mid career pay?

Let’s take a closer look at Iowa

Stem percent